package com.eduction.service;

import java.sql.SQLException;
import java.util.List;

import com.eduction.modules.system.entity.CourseRecordMap;

public interface CourseRecordMapService {
	/**
	 * 添加一张新表
	 */
	public void saveCourseRecordMap(CourseRecordMap c);
	/**
	 * 修改表的填报状态
	 */
	public void updateCourseRecordMapState(String sign,String schoolId,String expertId) throws SQLException;

	/**
	 * 查询这个专家填写的所有表
	 * @throws SQLException 
	 */
	public List<CourseRecordMap> queryMapsByExpert(String expertId,String identity) throws SQLException;

	/**
	 * 查询表是否存在
	 * @param sign
	 * @param schoolId
	 * @param expertId
	 * @return
	 */
	CourseRecordMap queryCourseRecordById(String sign, String schoolId, String expertId) throws SQLException;

	/**
	 * 根据id获取关系表
	 * @param pid
	 * @return
	 */
	CourseRecordMap findByPid(String pid);

	/**
	 * 根据id删除关系表
	 * @param pid
	 */
	void deleteByPid(String pid);
	/**
	 * 根据学校查询随堂听课记录
	 */
	List<CourseRecordMap> queryMapsBySchoolId(String schoolId)  throws SQLException ;
}
